﻿Use DangKyMonHocHocPhi;
Go
insert into NHANVIEN values ('NV0000005', 'Administrator', '1992-01-02 00:00:00', 'Nam', N'Địa Chỉ Đây ;)', 0123456789, NULL, 'admin', '21232f297a57a5a743894a0e4a801fc3');
Go
CREATE PROCEDURE [dbo].[GetEmployeeByUserPasswordFromDatabase]
(@TenDangNhap nvarchar(255), @MatKhau nvarchar(255))
AS
BEGIN
	SELECT * FROM NHANVIEN WHERE TenDangNhap=@TenDangNhap and MatKhau=@MatKhau;
END
RETURN